How to convert condition based rows into tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2812827%22%20slang%3D%22en-US%22%3EHow%20to%20convert%20condition%20based%20rows%20into%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812827%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20sheet%20with%20me%20in%20which%20user%20data%20is%20saved%20in%20rows%20but%20I%20have%20to%20convert%20it%20into%20coloumns.%20Explaining%20below%20what%20I%20mean.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20table%20that%20I%20have.%3C%2FP%3E%3CTABLE%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3ECustomer%20Id%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3EMonth%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3EOrders%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3CTD%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSTRONG%3EGMV%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E01%2F08%2F18%200%3A00%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E0.31%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E01%2F09%2F18%200%3A00%3C%2FTD%3E%3CTD%3E200%3C%2FTD%3E%3CTD%3E0.43%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E01%2F10%2F18%200%3A00%3C%2FTD%3E%3CTD%3E150%3C%2FTD%3E%3CTD%3E0.43%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E01%2F11%2F18%200%3A00%3C%2FTD%3E%3CTD%3E1201%3C%2FTD%3E%3CTD%3E0.42%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E01%2F08%2F18%200%3A00%3C%2FTD%3E%3CTD%3E12312%3C%2FTD%3E%3CTD%3E0.12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E01%2F09%2F18%200%3A00%3C%2FTD%3E%3CTD%3E213134%3C%2FTD%3E%3CTD%3E0.68%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E01%2F10%2F18%200%3A00%3C%2FTD%3E%3CTD%3E3453%3C%2FTD%3E%3CTD%3E0.52%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E01%2F11%2F18%200%3A00%3C%2FTD%3E%3CTD%3E54%3C%2FTD%3E%3CTD%3E0.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E01%2F08%2F18%200%3A00%3C%2FTD%3E%3CTD%3E35%3C%2FTD%3E%3CTD%3E2.3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E01%2F09%2F18%200%3A00%3C%2FTD%3E%3CTD%3E345%3C%2FTD%3E%3CTD%3E6.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E01%2F10%2F18%200%3A00%3C%2FTD%3E%3CTD%3E345%3C%2FTD%3E%3CTD%3E0.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E01%2F11%2F18%200%3A00%3C%2FTD%3E%3CTD%3E43532%3C%2FTD%3E%3CTD%3E10.4%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20in%20this%20table%2C%20every%20customer%20id%20(col%231)%20has%20a%20different%20GMV(col%20%233)%20for%20a%20fixed%20set%20of%20months%20(col%20%232)%20.%20I%20am%20trying%20to%20convert%20this%20table%20into%20columns.%20Something%20like%20this.%3C%2FP%3E%3CTABLE%20border%3D%221%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSTRONG%3ECustomer%20id%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E01%2F08%2F18%200%3A00%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E01%2F09%2F18%200%3A00%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E01%2F10%2F18%200%3A00%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E01%2F11%2F18%200%3A00%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0.31%3C%2FTD%3E%3CTD%3E0.43%3C%2FTD%3E%3CTD%3E0.43%3C%2FTD%3E%3CTD%3E0.42%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E0.12%3C%2FTD%3E%3CTD%3E0.68%3C%2FTD%3E%3CTD%3E0.52%3C%2FTD%3E%3CTD%3E0.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E2.3%3C%2FTD%3E%3CTD%3E6.2%3C%2FTD%3E%3CTD%3E0.2%3C%2FTD%3E%3CTD%3E10.4%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20achieve%20this%3F%3C%2FP%3E%3CP%3EP.S.%20This%20is%20a%20small%20subset%20of%20the%20original%20data%20--%20attaching%20an%20excel%20file%20too%20in%20case%20needed%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2812827%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

hi,

I have an excel sheet with me in which user data is saved in rows but I have to convert it into coloumns. Explaining below what I mean.

 

This is table that I have.

Customer IdMonthOrdersGMV
101/08/18 0:001000.31
101/09/18 0:002000.43
101/10/18 0:001500.43
101/11/18 0:0012010.42
201/08/18 0:00123120.12
201/09/18 0:002131340.68
201/10/18 0:0034530.52
201/11/18 0:00540.1
301/08/18 0:00352.3
301/09/18 0:003456.2
301/10/18 0:003450.2
301/11/18 0:004353210.4

 

As you can see in this table, every customer id (col#1) has a different GMV(col #3) for a fixed set of months (col #2) . I am trying to convert this table into columns. Something like this.

Customer id01/08/18 0:0001/09/18 0:0001/10/18 0:0001/11/18 0:00
10.310.430.430.42
20.120.680.520.1
32.36.20.210.4

 

Is there a way I can achieve this?

P.S. This is a small subset of the original data -- attaching an excel file too in case needed

 

2 Replies

@priyankagarwal Perhaps pivot table like in the attached file?

 

 

select range of the table and copy it and use paste special(control+alt+v)press and select transpose and click ok then rows will convert into colums ,this will work definetly,please try it