Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
clem312
Resolver I
Resolver I

Transpose ?

Hello,

 

I need to have QUOTA7 (value of QuestionShortCut) to become column with ResponseText as values in it.

and another column with PAYS (another value of QuestionShortCut) to become another column with ResponseText as value too.

 

clem312_0-1645116328389.png

 

Clement

1 ACCEPTED SOLUTION
clem312
Resolver I
Resolver I

@AlexisOlson I was able to make it adding conditonal columns.
Thank you for your help.

View solution in original post

3 REPLIES 3
clem312
Resolver I
Resolver I

@AlexisOlson I was able to make it adding conditonal columns.
Thank you for your help.

clem312
Resolver I
Resolver I

Hi Alexis,

 

I hope this can help :

QuotaParentToken	QuestionId	QuestionType	QuestionShortcut	QuestionImport	QuestionImportType	QuestionClosedImportType	ResponseId	ResponseText	MinimumTargetCount
192	316	1	QUOTA7	QUOTA7	3	0	28666	3760202	75
380	316	1	QUOTA7	QUOTA7	3	0	28651	3157401	0
568	316	1	QUOTA7	QUOTA7	3	0	28617	0968412	15
568	316	1	QUOTA7	QUOTA7	3	0	28622	0971201	9
568	316	1	QUOTA7	QUOTA7	3	0	28623	0971202	30
380	316	1	QUOTA7	QUOTA7	3	0	28663	3365212	3
380	316	1	QUOTA7	QUOTA7	3	0	28658	3363502	9
380	316	1	QUOTA7	QUOTA7	3	0	28659	3363503	2
380	316	1	QUOTA7	QUOTA7	3	0	28660	3364412	3
380	316	1	QUOTA7	QUOTA7	3	0	28661	3364413	0
380	316	1	QUOTA7	QUOTA7	3	0	28662	3365211	0
196	1323	1	QUOTA7	QUOTA7	3	0	34358	5660412	0
196	1323	1	QUOTA7	QUOTA7	3	0	34359	5660414	0
380	316	1	QUOTA7	QUOTA7	3	0	28664	3374414	0
380	316	1	QUOTA7	QUOTA7	3	0	28665	3375222	0
380	316	1	QUOTA7	QUOTA7	3	0	28666	3760202	0
380	316	1	QUOTA7	QUOTA7	3	0	28667	3760205	9
380	316	1	QUOTA7	QUOTA7	3	0	28668	3760207	0
380	316	1	QUOTA7	QUOTA7	3	0	28669	3760209	0
380	316	1	QUOTA7	QUOTA7	3	0	28670	3760210	0
380	316	1	QUOTA7	QUOTA7	3	0	28671	3760211	0
380	316	1	QUOTA7	QUOTA7	3	0	28672	3760212	0
380	316	1	QUOTA7	QUOTA7	3	0	28673	3761527	29
380	316	1	QUOTA7	QUOTA7	3	0	28674	3763402	4
380	316	1	QUOTA7	QUOTA7	3	0	28675	3763403	3
380	316	1	QUOTA7	QUOTA7	3	0	28676	3770290	0
380	316	1	QUOTA7	QUOTA7	3	0	28677	5061401	15
380	316	1	QUOTA7	QUOTA7	3	0	28678	5062201	22
380	316	1	QUOTA7	QUOTA7	3	0	28679	5660412	0
380	316	1	QUOTA7	QUOTA7	3	0	28680	5660414	0
380	316	1	QUOTA7	QUOTA7	3	0	28681	5660415	0
380	316	1	QUOTA7	QUOTA7	3	0	28682	5660422	16
380	316	1	QUOTA7	QUOTA7	3	0	28683	5660424	18
380	316	1	QUOTA7	QUOTA7	3	0	28684	5660425	0
380	316	1	QUOTA7	QUOTA7	3	0	28685	5662214	24
380	316	1	QUOTA7	QUOTA7	3	0	28686	5662215	7
380	316	1	QUOTA7	QUOTA7	3	0	28687	5666416	0
380	316	1	QUOTA7	QUOTA7	3	0	28688	5666426	24
380	316	1	QUOTA7	QUOTA7	3	0	28689	5667511	14
0	145	1	PAYS	PAYS	3	2	984	4 ESPAGNE	1256
568	316	1	QUOTA7	QUOTA7	3	0	-1	NULL	0
568	316	1	QUOTA7	QUOTA7	3	0	28598	0663502	23
568	316	1	QUOTA7	QUOTA7	3	0	28599	0663503	0
196	1323	1	QUOTA7	QUOTA7	3	0	34357	5062201	0
572	1323	1	QUOTA7	QUOTA7	3	0	34340	3364413	0
768	1323	1	QUOTA7	QUOTA7	3	0	34332	3157412	0
380	316	1	QUOTA7	QUOTA7	3	0	28652	3157411	16
380	316	1	QUOTA7	QUOTA7	3	0	28653	3157412	0
380	316	1	QUOTA7	QUOTA7	3	0	28654	3158202	9
380	316	1	QUOTA7	QUOTA7	3	0	28655	3160501	25
380	316	1	QUOTA7	QUOTA7	3	0	28656	3160502	1
380	316	1	QUOTA7	QUOTA7	3	0	28657	3167413	1
196	1323	1	QUOTA7	QUOTA7	3	0	34360	5660415	0
568	316	1	QUOTA7	QUOTA7	3	0	28600	0664412	17
196	1323	1	QUOTA7	QUOTA7	3	0	34361	5660422	0
196	1323	1	QUOTA7	QUOTA7	3	0	34362	5660424	15
196	1323	1	QUOTA7	QUOTA7	3	0	34363	5660425	0
196	1323	1	QUOTA7	QUOTA7	3	0	34364	5662214	0
196	1323	1	QUOTA7	QUOTA7	3	0	34365	5662215	0
196	1323	1	QUOTA7	QUOTA7	3	0	34366	5666416	0
196	1323	1	QUOTA7	QUOTA7	3	0	34367	5666426	0
196	1323	1	QUOTA7	QUOTA7	3	0	34368	5667511	0
4	145	1	PAYS	PAYS	3	2	983	3 ITALIE	35
384	1323	1	QUOTA7	QUOTA7	3	0	-1	NULL	0
384	1323	1	QUOTA7	QUOTA7	3	0	34277	0663502	2
384	1323	1	QUOTA7	QUOTA7	3	0	34278	0663503	0
384	1323	1	QUOTA7	QUOTA7	3	0	34279	0664412	4
384	1323	1	QUOTA7	QUOTA7	3	0	34280	0664413	0
AlexisOlson
Super User
Super User

I think you want to pivot rather than transpose.

 

However, the other columns might cause complications. If you need help with that, please provide some sample data in a format others can load or copy & paste from along with an example of what end result from that sample data should be.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors