copy data from column to row

[288enzo]

Hi, I've done some searching and have found a few examples but they don't seem to be a match for me. Hope someone here can help.

I have a sheet called "example" where all my data is, I'd like to copy output data from "example" to "data".

example!B1 copied to data!A7
example!D1 copied to data!B7
example!B4 copied to data!C7

example!F1 copied to data!A8
example!H1 copied to data!B8
example!F4 copied to data!C8

example!J1 copied to data!A9
example!L1 copied to data!B9
example!J4 copied to data!C9

The above will have 100 or more examples.

Thanks, this forum is a life saver

[quekbc]

Seems like you may need a VBA solution for this.

Regardless, it would be helpful if you could post a sample spreadsheet with sensitive data removed with details on the desired output that you want.

To attach a file, click on "Go Advanced" just below the Quick Reply box, and follow the instructions on Manage Attachments at the bottom of the resulting website.

[Pete_UK]

Use these formulae in the cells stated on the Data sheet:

A7: =INDEX(Example!$1:$1,(ROWS($1:1)-1)*4+2)
B7: =INDEX(Example!$1:$1,ROWS($1:1)*4)
C7: =INDEX(Example!$4:$4,(ROWS($1:1)-1)*4+2)

then copy down as required.

Hope this helps.

Pete

[288enzo]

Use these formulae in the cells stated on the Data sheet:

A7: =INDEX(Example!$1:$1,(ROWS($1:1)-1)*4+2)
B7: =INDEX(Example!$1:$1,ROWS($1:1)*4)
C7: =INDEX(Example!$4:$4,(ROWS($1:1)-1)*4+2)

then copy down as required.

Hope this helps.

Pete

This is great and worked perfectly! Thank you so very much.

[Pete_UK]

You're welcome - thanks for feeding back.

Pete