| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need to reorganize - transpose columns to rows per article number
I have a list with five columns. Every row contains following data:
Column A contains article number. Column B-E contains info about where to find pictures. It looks like this: Article Info 1 Info 2 Info 3 Info 4 500086 black blue white yellow 500087 black red blue green I would like to extract data in a different format. I would like it to look like this: Article Number Info 500086 1 black 500086 2 blue 500086 3 white 500086 4 yellow 500087 1 black 500087 2 red 500087 3 blue 500087 4 green I suppose I need a macro? My list is about 1200 articles. Note that the second column should go from 1 to 4 all over. Thanks Tobias |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
| Transpose a .csv from columns to rows | Excel Programming | |||
| transpose 7 rows/7 columns | Excel Programming | |||
| how do I transpose columns and rows | Excel Discussion (Misc queries) | |||
| transpose 255+ columns into rows? | Excel Programming | |||
Threaded Mode
