Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with transposing
Hi All,
I need help with transposigng rows into columns. here is what i have colA ColB aaa 11 aaa 22 aaa 33 aaa 44 bbb 55 bbb 66 bbb 77 ccc 88 ccc 99 And this is what I need after transposing. aa 11 22 33 44 bbb 55 66 66 ccc 88 99 Is there a way to do this using transposing? Or by using Pivot tables? Please let me know |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with transposing
Insert a column to the LEFT of your data.
Thus what was your ColA is now in column B. Put a header on the new column of "Col_Lbls". In cell A2, assuming the row of "aaa" and 11 is in row 2, enter the formula: =If(Exact(B1,B2),A1+1,1) Copy the formula down as many rows as necessary. Now, using your data and this new column, create a Pivot Table on a new worksheet. In the Row Labels put ColA. In the Column Labels put Col_Lbls (the new column). In the Values put ColB. This should provide you with what you were requesting. Good Luck. " wrote: Hi All, I need help with transposigng rows into columns. here is what i have colA ColB aaa 11 aaa 22 aaa 33 aaa 44 bbb 55 bbb 66 bbb 77 ccc 88 ccc 99 And this is what I need after transposing. aa 11 22 33 44 bbb 55 66 66 ccc 88 99 Is there a way to do this using transposing? Or by using Pivot tables? Please let me know |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with transposing
On Oct 27, 5:51*pm, ND Pard wrote:
Insert a column to the LEFT of your data. Thus what was your ColA is now in column B. Put a header on the new column of "Col_Lbls". In cell A2, assuming the row of "aaa" and 11 is in row 2, enter the formula: *=If(Exact(B1,B2),A1+1,1) Copy the formula down as many rows as necessary. Now, using your data and this new column, create a Pivot Table on a new worksheet. In the Row Labels put ColA. In the Column Labels put Col_Lbls (the new column). In the Values put ColB. This should provide you with what you were requesting. Good Luck. " wrote: Hi All, I need help with transposigng rows into columns. here is what i have colA ColB aaa * * * *11 aaa * * * *22 aaa * * * *33 aaa * * * *44 bbb * * * *55 bbb * * * *66 bbb * * * *77 ccc * * * *88 ccc * * * *99 And this is what I need after transposing. aa 11 * * *22 * * *33 * * *44 bbb * * * *55 * * *66 * * *66 ccc * * * *88 * * *99 Is there a way to do this using transposing? Or by using Pivot tables? Please let me know- Hide quoted text - - Show quoted text - Thanks a lot. It works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing | Excel Discussion (Misc queries) | |||
Transposing | Excel Worksheet Functions | |||
Transposing data | New Users to Excel | |||
Variable Transposing | Excel Discussion (Misc queries) | |||
TRANSPOSING | Excel Discussion (Misc queries) |