Converting rows to columns in different sheets

[s.tara91]

Hiya,

I am trying to get the information from one sheet that goes along a row to another sheet that will have the information going down a column.

I want the columns to go down each cell changing the Alpha but not the Number so A1, B1, C1 and need whatever information is in the first sheet to flow through to the second sheet if it changes without having to change anything in the second sheet and want to be able to drag down A B C without manually typing.

Any help would be amazing.

Thanks

[:) Sixthsense :)]

Please attach a sample workbook with dummy data by covering the expected output for better understanding

[judgeh59]

without seeing the worksheet it sounds like the transpose (paste) function might be your answer....the transpose is in the special paste area....basically. highlight your data, cntl-C, then go to your new worksheet and right click and go to paste special you should see a transpose radio button....HTH

[s.tara91]

Hi,

I have now attached the spreadsheet i am working on.

Thanks for any help in advance

[s.tara91]

Sorry this one is not password protected

[:) Sixthsense :)]

In A1 cell of PAYROLL SUMMARY sheet

Please Login or Register  to view this content.

Drag it down...

[s.tara91]

Thankyou, that works perfectly!

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback

[s.tara91]

Hello, Is there a way to be able to use this formula the opposite way so converting columns to rows? In the same spreadsheet.

Thanks

[:) Sixthsense :)]

Try like this...

In B1 Cell

Please Login or Register  to view this content.

[s.tara91]

Thanks so much! Lifesaver!

[s.tara91]

Hiya,

Just having a problem with the last formula. It all works well until i completely remove a row in the first sheet as then i have to go and change the formulas.

Any suggestions?

Thanks

[:) Sixthsense :)]

Deleting the rows cause the formula to decrease the formula range have you seen the formula reference after deleting certain rows?

[s.tara91]

Once i delete certain rows it says =INDEX('Feb13'!#REF!,,ROW(H1))

Id like the spreadsheet to pick up whatever is in the row so if say row 10 is removed that data is gone but the previous row 11 is now row 10 so whatever is in there needs to be picked up in the same column as old row 10.

I have attached the most recent copy of what im working on so you can have a look.

Thanks

[:) Sixthsense :)]

Try this...

In B1 Cell

Please Login or Register  to view this content.

Drag it right...

In B2 Cell

Please Login or Register  to view this content.

Drag it down and right...

[s.tara91]

That is working very well for me now.

Thanks for all of your help!

You are the Excel master!