Fields with no data

[Analytics_Pooja]

I have a dataset with a field called BM. There could be n number of Business Managers for each Identifier at given point of time. I am transposing the data to get different fields as BM1, BM2, BM3 and so on. I want fields upto BM5 even if BM4 and BM5 doesn't exists. For example

Identifier	BM
1	Steve
1	Neha
1	Richard
2	Usha
2	Mandy
2	Nancy
Output
Identifier	BM1	BM2	BM3	BM4	BM5
1	Steve	Neha	Richard
2	Usha	Mandy	Nancy

I want BM4 and BM5 as blank columns even if there is no data. 

Any kind of help would be appreciated.

Best

Pooja 

[gabrielvilella]

Hey @Analytics_Pooja, here is one way you can do this.

[Qiu]

@Analytics_Pooja 
here is my try.

[Analytics_Pooja]

@gabrielvilella transposing data is not a problem. Problem is to create BM4 and BM4 that doesn't exist in the current data but likely to get populated in next data. 

[gabrielvilella]

See if this is what you are looking for.

[binuacs · Accepted solution]

@Analytics_Pooja