I have a 3 row spreadsheet that needs to be separated into multiple columns. Row 1 is the unique value. Row 2 will become the column name. Row 3 contains the data for the column. Ultimately will result in about 200 columns.
Is there a good formula that would accomplish this? Thanks in advance.
Sample Current format
<tbody>
</tbody>
Sample Desired output
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 134px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody>
Is there a good formula that would accomplish this? Thanks in advance.
Sample Current format
PART1 | MANUFACTURER | NAME |
PART1 | MANUFACTURER PART NUMBER | 1 |
PART2 | MANUFACTURER | NAME |
PART2 | MANUFACTURER PART NUMBER | 2 |
PART3 | MANUFACTURER | NAME |
PART3 | MANUFACTURER PART NUMBER | 3 |
PART4 | MANUFACTURER | NAME |
PART4 | MANUFACTURER PART NUMBER | 4 |
<tbody>
</tbody>
Sample Desired output
MANUFACTURER PART NUMBER | MANUFACTURER | |
PART1 | 1 | NAME |
PART2 | 2 | NAME |
PART3 | 3 | NAME |
PART4 | 4 | NAME |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 134px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
MANUFACTURER |
<tbody>
</tbody>