Extract Data from Table into Columns

[wildturkey]

HI, clutching at straws but looking to take the small table and format as the three columns below...the actual table is a little bigger hence the ask

Book3
	A	B	C	D	E	F	G
1	Inc Items	Bob	Jane	David	Emma	Tom
2	Apple	21.85	20.29	23.2	20.29	20.85
3	Pear	23.28	21.41	25.07	21.41	22.28
4	Carrot	38.95	36.71	52.49	36.71	37.95
5	Ptato	50.35	48.94	55.59	48.94	49.35
6	Grape	33.92	40.05	43.8	40.05	33.92
7	Carrot	61.75	67.1	77.49	67.1	60.75
8	Tomato	7.32	6.68	8.89	6.68	6.92
9
10
11
12
13	Inc Items
14	Apple	Bob	21.85
15	Pear	Bob	23.28
16	Carrot	Bob	38.95
17	Ptato	Bob	50.35
18	Grape	Bob	33.92
19	Carrot	Bob	61.75
20	Tomato	Bob	7.32
21	Apple	Jane	20.29
22	Pear	Jane	21.41
23	Carrot	Jane	36.71
24	Ptato	Jane	48.94
25	Grape	Jane	40.05
26	Carrot	Jane	67.1
27	Tomato	Jane	6.68
28	Apple	David	23.2
29	Pear	David	25.07
30	Carrot	David	52.49
31	Ptato	David	55.59
Sheet1

 

[Kerryx]

Easy with PQ

Book1
	A	B	C	D	E	F
1	Inc Items	Bob	Jane	David	Emma	Tom
2	Apple	21.85	20.29	23.2	20.29	20.85
3	Pear	23.28	21.41	25.07	21.41	22.28
4	Carrot	38.95	36.71	52.49	36.71	37.95
5	Ptato	50.35	48.94	55.59	48.94	49.35
6	Grape	33.92	40.05	43.8	40.05	33.92
7	Carrot	61.75	67.1	77.49	67.1	60.75
8	Tomato	7.32	6.68	8.89	6.68	6.92
9
10
11
12
13	Inc Items			Inc Items	Attribute	Value
14	Apple	Bob	21.85	Grape	Bob	33.92
15	Pear	Bob	23.28	Pear	Bob	23.28
16	Carrot	Bob	38.95	Carrot	Bob	38.95
17	Ptato	Bob	50.35	Ptato	Bob	50.35
18	Grape	Bob	33.92	Carrot	Bob	61.75
19	Carrot	Bob	61.75	Tomato	Bob	7.32
20	Tomato	Bob	7.32	Apple	Bob	21.85
21	Apple	Jane	20.29	Tomato	David	8.89
22	Pear	Jane	21.41	Carrot	David	52.49
23	Carrot	Jane	36.71	Carrot	David	77.49
24	Ptato	Jane	48.94	Grape	David	43.8
25	Grape	Jane	40.05	Ptato	David	55.59
26	Carrot	Jane	67.1	Apple	David	23.2
27	Tomato	Jane	6.68	Pear	David	25.07
28	Apple	David	23.2	Ptato	Emma	48.94
29	Pear	David	25.07	Carrot	Emma	67.1
30	Carrot	David	52.49	Apple	Emma	20.29
31	Ptato	David	55.59	Pear	Emma	21.41
32				Grape	Emma	40.05
33				Carrot	Emma	36.71
34				Tomato	Emma	6.68
35				Carrot	Jane	67.1
36				Apple	Jane	20.29
37				Tomato	Jane	6.68
38				Ptato	Jane	48.94
39				Grape	Jane	40.05
40				Carrot	Jane	36.71
41				Pear	Jane	21.41
42				Tomato	Tom	6.92
43				Pear	Tom	22.28
44				Carrot	Tom	37.95
45				Apple	Tom	20.85
46				Grape	Tom	33.92
47				Ptato	Tom	49.35
48				Carrot	Tom	60.75
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Inc Items", type text}, {"Bob", type number}, {"Jane", type number}, {"David", type number}, {"Emma", type number}, {"Tom", type number}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Inc Items"}, "Attribute", "Value"),
    #"Sorted Rows" = Table.Sort(#"Unpivoted Columns",{{"Attribute", Order.Ascending}})
in
    #"Sorted Rows"

 

[wildturkey]

Thank you!

 

[Fluff]

Another option with a formula

Fluff.xlsm
	A	B	C	D	E	F
1	Inc Items	Bob	Jane	David	Emma	Tom
2	Apple	21.85	20.29	23.2	20.29	20.85
3	Pear	23.28	21.41	25.07	21.41	22.28
4	Carrot	38.95	36.71	52.49	36.71	37.95
5	Ptato	50.35	48.94	55.59	48.94	49.35
6	Grape	33.92	40.05	43.8	40.05	33.92
7	Carrot	61.75	67.1	77.49	67.1	60.75
8	Tomato	7.32	6.68	8.89	6.68	6.92
9
10
11
12
13	Inc Items
14	Apple	Bob	21.85
15	Pear	Bob	23.28
16	Carrot	Bob	38.95
17	Ptato	Bob	50.35
18	Grape	Bob	33.92
19	Carrot	Bob	61.75
20	Tomato	Bob	7.32
21	Apple	Jane	20.29
22	Pear	Jane	21.41
23	Carrot	Jane	36.71
24	Ptato	Jane	48.94
25	Grape	Jane	40.05
26	Carrot	Jane	67.1
27	Tomato	Jane	6.68
28	Apple	David	23.2
29	Pear	David	25.07
30	Carrot	David	52.49
31	Ptato	David	55.59
32	Grape	David	43.8
33	Carrot	David	77.49
34	Tomato	David	8.89
35	Apple	Emma	20.29
36	Pear	Emma	21.41
37	Carrot	Emma	36.71
38	Ptato	Emma	48.94
39	Grape	Emma	40.05
40	Carrot	Emma	67.1
41	Tomato	Emma	6.68
42	Apple	Tom	20.85
43	Pear	Tom	22.28
44	Carrot	Tom	37.95
45	Ptato	Tom	49.35
46	Grape	Tom	33.92
47	Carrot	Tom	60.75
48	Tomato	Tom	6.92
Sheet6

Cell Formulas
Range	Formula
A14:C48	A14	=HSTACK(TOCOL(IF(B2:F8<>"",A2:A8,1/0),2,1),TOCOL(IF(B2:F8<>"",B1:F1,1/0),2,3),TOCOL(B2:F8,1,1))
Dynamic array formulas.

 

[wildturkey]

That's great thankyou - power quey is on my list though

 

[Fluff]

Glad we could help & thanks for the feedback.