I would like to transpose rows to columns. From Image:
I’d like to transpose based on frequency_band and RRH_ANY_BAND with USIDN being the common value in initial data set. Some USIDN have 2 rows and some with 3 rows (not shown). In the image I forgot to do a mockup for Band3 .
I’d rather do using sql and not via the Pivot & Chart grid (unless I can get the statements from that grid)