I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.

I can do this through the pivot table, but this is a long drawn out process.

Any ideas

I'm not sure if this will work for you, but you can try this:

- Highlight & copy on the horizontal value you want to make vertical
- Now highlight the vertical area you want these value to got
- Right Click when highlighted & choose Paste Special
- Check the Transpose box at the bottom & choose OK

"doulos" wrote:

I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.

I can do this through the pivot table, but this is a long drawn out process.

Any ideas