LinkBack URL
About LinkBacks
Hello:
Please refer to attached file.
I have daily Data as shown in sheet1.
I need to transpose this data with formula as outlined in Sheet2.
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have daily Data as shown in sheet1.
I need to transpose this data with formula as outlined in Sheet2.
Let me know if you have any questions.
Thanks.
Riz
You can use a CSE formula in Sheet2
Place this in C2:L2 and commit with CSE
=TRANSPOSE(Sheet1!D2:D11)
I only went thru L2 because on Sheet1 you only went down 10 rows
HTH
Regards, Jeff
Hi Jeff:
Thanks for your suggestion but i tried and as you can see the data in sheet1 is in very 4th column.
So that is not giving correct result.
I will have this for the whole month.
Please check and let me know.
Thanks
Riz
Hello Guys:
Can you see if this can be done with INDIRECT function with row # etc.
Riz
Is the spacing of columns the same every time? if so you could use a index/match/match formula
formula in C1 fill right and across
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 11-23-2015 at 08:21 PM. Reason: file attached
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try putting this in cell C3 of Sheet2 and drag it across and down:
=OFFSET(Sheet1!$D$2,COLUMN()-3,4*(ROW()-2))
It's using the formula's current row/column location to create a transposed offset from an anchored cell in Sheet1.
Hi clabulis:
Your formula will work for me.
i will test more and let you know if any issues.
Thanks
Riz
Hi Hundingaling:
Would work but formula by Clabulis" is easy to understand and easy to use.
Thanks a lot
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks