LinkBack URL
About LinkBacks
Hi,
I am confused with a formula similar to copy and paste (transpose) that change the position of the data from the column into a row
is there a formula that can do it
regads
Hi,
I am confused with a formula similar to copy and paste (transpose) that change the position of the data from the column into a row
is there a formula that can do it
regads
If the data is always in the same place you could always use =B1
or
Create a macro and assign it to a button...
Icartwright, Im not sure I understand how =B1 is going to do this for the OP - and still return the data in the format they require?
If having that gap/repeat in I3:L3 is not important, try this instead
a b
J7=IFERROR(INDEX($D$2:$D$6,MATCH(J$6&$I7,INDEX($B$2:$B$6&$C$2:$C$6,0),0)),"")
copied down and across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hi Icarwright,
I want excel formula to used, may be similar to the "index" or something like that.
with consideration macros heavier than excel formula
data source is dynamic
anyway thanks,
Hello FDibbins,
in I3:L3 is not repeat value there also transpose value from B2:B6 based on C .
Now I am still trying to formula you suggest
thanks
for more details, I attach the second table,
thanks
Did you even try my suggestion yet?
changed the formula to...
=IFERROR(INDEX($D$2:$D$6,MATCH(R$1&Q4,INDEX($B$2:$B$6&$C$2:$C$6,0),0)),"")
hi FDibbins,
I've tried both and it did not work, produce ""
any time the data will change like this (attachment)
Try this (Tab 2)
Formula Transpose column to row(2).xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks