On the excel table transformation-CodePudding

How can quickly convert the content of the picture 1 to the format of the picture 2, namely 1 code 1 name

CodePudding user response:

Don't use vba just need some simple function of excel word can pass the following,
1. First of all, this form can be sheet1, copy once we call the form of the sheet2,
2. In sheet2 combine level 1 subject inside out, and belongs to all fill in the cement concrete, kuangfen place all fill in the mineral powder, such as cement, cement, cement, mineral powder, mineral powder, mineral powder, colour sand, sand texture, colour sand, sand color, white cement...
3. Then write a function in sheet2, judge whether the content of the sheet1 the same position as the empty string, if not is equal to the following cell (based on current cell, level course in the cell, the secondary subjects the same cell as well as the contents of the first column on the left of the text together,
4. You can copy sheet2 inside all cells on 3 written inside function, then there is a number in sheet1 place according to the corresponding model,
5. I see you in sheet1 model is not a lot of, can according to the corresponding relations between a line a line of copy, according to your picture format to create a new form of 2 we called sheet3, make a copy of the inside of the sheet1 number in the first column, put the content inside the sheet2 you just paste the way of data in the second column,

CodePudding user response:

reference 1 floor nashma. Blog. Jp response:

without vba just need some simple function of excel word can through the following operation,
1. First of all, this form can be sheet1, copy once we call the form of the sheet2,
2. In sheet2 combine level 1 subject inside out, and belongs to all fill in the cement concrete, kuangfen place all fill in the mineral powder, such as cement, cement, cement, mineral powder, mineral powder, mineral powder, colour sand, sand texture, colour sand, sand color, white cement...
3. Then write a function in sheet2, judge whether the content of the sheet1 the same position as the empty string, if not is equal to the following cell (based on current cell, level course in the cell, the secondary subjects the same cell as well as the contents of the first column on the left of the text together,
4. You can copy sheet2 inside all cells on 3 written inside function, then there is a number in sheet1 place according to the corresponding model,
5. I see you in sheet1 model is not a lot of, can according to the corresponding relations between a line a line of copy, according to your picture format to create a new form of 2 we called sheet3, make a copy of the inside of the sheet1 number in the first column, put the content inside the sheet2 you just paste the way of data in the second column,

Studied the

CodePudding user response:

Online software excel operation

CodePudding user response:

reference 1 floor nashma. Blog. Jp response:

without vba just need some simple function of excel word can through the following operation,
1. First of all, this form can be sheet1, copy once we call the form of the sheet2,
2. In sheet2 combine level 1 subject inside out, and belongs to all fill in the cement concrete, kuangfen place all fill in the mineral powder, such as cement, cement, cement, mineral powder, mineral powder, mineral powder, colour sand, sand texture, colour sand, sand color, white cement...
3. Then write a function in sheet2, judge whether the content of the sheet1 the same position as the empty string, if not is equal to the following cell (based on current cell, level course in the cell, the secondary subjects the same cell as well as the contents of the first column on the left of the text together,
4. You can copy sheet2 inside all cells on 3 written inside function, then there is a number in sheet1 place according to the corresponding model,
5. I see you in sheet1 model is not a lot of, can according to the corresponding relations between a line a line of copy, according to your picture format to create a new form of 2 we called sheet3, make a copy of the inside of the sheet1 number in the first column, put the content inside the sheet2 you just paste the way of data in the second column,

I have considered your methods, but this is very time consuming, I give is one of the sheet, there are many like this sheet, request the practice of vba, thank you

CodePudding user response:

reference 4 floor zhouguoguang response:

Quote: reference 1 floor nashma. Blog. Jp response:

Don't use vba just need some simple function of excel word can pass the following,
1. First of all, this form can be sheet1, copy once we call the form of the sheet2,
2. In sheet2 combine level 1 subject inside out, and belongs to all fill in the cement concrete, kuangfen place all fill in the mineral powder, such as cement, cement, cement, mineral powder, mineral powder, mineral powder, colour sand, sand texture, colour sand, sand color, white cement...
3. Then write a function in sheet2, judge whether the content of the sheet1 the same position as the empty string, if not is equal to the following cell (based on current cell, level course in the cell, the secondary subjects the same cell as well as the contents of the first column on the left of the text together,
4. You can copy sheet2 inside all cells on 3 written inside function, then there is a number in sheet1 place according to the corresponding model,
5. I see you in sheet1 model is not a lot of, can according to the corresponding relations between a line a line of copy, according to your picture format to create a new form of 2 we called sheet3, make a copy of the inside of the sheet1 number in the first column, put the content inside the sheet2 you just paste the way of data in the second column,

I have considered your methods, but this is very time consuming, I give is one of the sheet, there are many like this sheet, request the practice of vba, thank you

so, I think there is only one form

CodePudding user response:

VBA baidu about yourself can get all 14 years

CodePudding user response:

Title 1, 2, combined with the powerquery inverse perspective?