Transpose columns from 1 table and create a new table

[Deb3107]

Hi,

I have t able with 30+ columns in and I want to create another table with 3 columns from the original table then transpose 8 other columns into 1 column + a value column.

The 8 columns I want to transpose all have a value of true or false. 

 I tried creating a summary table first using the following

Unable to refer = SUMMARIZECOLUMNS('Growth Hub Referrals'[_new_growthhub_value],'Growth Hub Referrals'[new_growthhubreferralid],'Growth Hub Referrals'[Date],'Growth Hub Referrals'[alreadyreferred],'Growth Hub Referrals'[businessclosed],'Growth Hub Referrals'[businessincrisis],'Growth Hub Referrals'[camefromGH],'Growth Hub Referrals'[customerdeclined],'Growth Hub Referrals'[not eligible],'Growth Hub Referrals'[notinterested],'Growth Hub Referrals'[signposted])

But then I can't access it using Power Query. I don't want to change the existing table which is why I created the  unable to refer table.

Any ideas? Is this even possible?

Debra

[Anonymous]

Possible to upload some sample/dummy data with the expected output?

[Deb3107]

Hi,

this is some sample data

new_growthhubreferralid

_new_growthhub_value

createdon

unable_alreadyreferred

unable_businessclosed

unable_businessincrisis

unable_camefromGH

unable_customerdeclined

unable_not eligible

unable_notinterested

unable_signposted

new_ghrbusinessage

new_ghrbusinessagemeetshubrequirements

new_ghrbusinessclosed

new_ghrbusinessplanning

new_ghrdirectlyrequestedcontactwithgrowthhub

new_ghrcapitalequipmentpurchase

new_ghrgrowthpotential

new_ghrlookingtocompletestafftraining

new_ghrlookingtoexport

new_ghrlookingtorecruitstaff

new_ghrmeetsectorspecificrequirements

_new_case_value

6141476d-bd39-e911-a8be-00224801a32d

4aec0216-f3fe-e811-a8db-00224801ac12

26/02/2019 11:55

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

c9801ac1-3439-e911-a8d9-00224801a6b7

1ba970cc-d439-e911-a8e6-00224801a4ba

54ec0216-f3fe-e811-a8db-00224801ac12

26/02/2019 14:43

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

01bf2adb-c439-e911-a8d9-00224801a6b7

86702954-7b3a-e911-a8e6-00224801a4ba

54ec0216-f3fe-e811-a8db-00224801ac12

27/02/2019 10:35

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

06df1c7b-e139-e911-a8e7-00224801ae66

and this is how i need it to transpose to

_new_growthhub_value	createdon	Not referred Reason	Count
4aec0216-f3fe-e811-a8db-00224801ac12	26/02/2019 11:55	unable_alreadyreferred	2
54ec0216-f3fe-e811-a8db-00224801ac12	26/02/2019 14:43	unable_businessclosed	3
54ec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 10:35	unable_businessincrisis	5
68ec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 13:44	unable_camefromGH	7
8aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 14:04	unable_customerdeclined	9
64ec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 14:47	unable_not eligible	10
8eec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 16:36	unable_notinterested	11
7aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 16:57	unable_signposted	12
80ec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 17:23	unable_alreadyreferred	2
6aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 17:27	unable_businessclosed	3
7aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 17:35	unable_businessincrisis	5
7aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 17:51	unable_camefromGH	7
7aec0216-f3fe-e811-a8db-00224801ac12	27/02/2019 17:52	unable_customerdeclined	9
68ec0216-f3fe-e811-a8db-00224801ac12	28/02/2019 09:14	unable_not eligible	10
64ec0216-f3fe-e811-a8db-00224801ac12	28/02/2019 09:47	unable_notinterested	11
7aec0216-f3fe-e811-a8db-00224801ac12	28/02/2019 10:28	unable_signposted	12

Thanks

Debra