is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick
Insert a column between C & D to concatenate columns A, B, and C, like: A13 &"|" & B13 & "|" & C13
(you can only use one field for the next step ... and the "|" separators will allow you to split the field later on in the process)
Now use the range from the new column D12 downwards and rightwards for your source data table for normalizing your data this way:
When you have your final list, you can split your joined field using Data/Text To Columns ... either in a new area, or making space for the 1 to 3 column transformation.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
