How to convert condition based rows into tables

[priyankagarwal]

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 Id	Month	Orders	GMV
1	01/08/18 0:00	100	0.31
1	01/09/18 0:00	200	0.43
1	01/10/18 0:00	150	0.43
1	01/11/18 0:00	1201	0.42
2	01/08/18 0:00	12312	0.12
2	01/09/18 0:00	213134	0.68
2	01/10/18 0:00	3453	0.52
2	01/11/18 0:00	54	0.1
3	01/08/18 0:00	35	2.3
3	01/09/18 0:00	345	6.2
3	01/10/18 0:00	345	0.2
3	01/11/18 0:00	43532	10.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 id	01/08/18 0:00	01/09/18 0:00	01/10/18 0:00	01/11/18 0:00
1	0.31	0.43	0.43	0.42
2	0.12	0.68	0.52	0.1
3	2.3	6.2	0.2	10.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]

@priyankagarwal Perhaps pivot table like in the attached file?

[#3]

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