Turning a Table into a sorted Column

[KongGulerod]

Hi.

I'm working on a vacation calendar for a group of teams.

I have the data in a table like this:

group	name	location
TeamA	Person1	S
TeamA	Person2	R
TeamA	Person3	P
TeamA	Person4	S
TeamB	Person5	R
TeamB	Person6	P
TeamB	Person7	S
TeamB	Person8	R
TeamB	Person9	P
TeamB	Person10	S
TeamC	Person11	R
TeamC	Person12	P

But would like to have the data like:

TeamA

Person1

Person2

Person3

Person4

TeamB

Person5

Person6

Person7

Person8

Person9

Person10

TeamC

Person11

Person12

Is that possible without a macro?
Would it be possible to sort the persons according to the location too?

Kind regards J

 

[sandy666]

with Power Query
is that what you want?

 

[sandy666]

and...

 

[KongGulerod]

with Power Query
is that what you want?

View attachment 5304

Just talked to IT Power Query is a no go.
It has to work in a standard Excel 2013.

Maybe I should just wait for the 2016 update!

 

[sandy666]

Maybe I should just wait for the 2016 update!

or higher

Just talked to IT Power Query is a no go.
It has to work in a standard Excel 2013.

I don't understand that
2016 with Power Query is OK
2013 with Power Query is NOT OK
IT, are you afraid about unknown?

 

[KongGulerod]

or higher


I don't understand that
2016 with Power Query is OK
2013 with Power Query is NOT OK
IT, are you afraid about unknown?

We are a "bit" behind on office versions...

I thought 2016 had power query in the standard install, am I wrong there?

 

[sandy666]

Power Query & Power Pivot - built-in

I've never had a standard version so I don't know

 

[KongGulerod]

View attachment 5308
Power Query & Power Pivot - built-in

I've never had a standard version so I don't know

I'll ask my boss to make sure we get an upgrade soon.

Power Query is "built in" to 2016 and newer.

 

[sandy666]

Remember about Pro Plus

btw. Update profile (Account details) about Excel version - less troubles & wasted posts

 

[KongGulerod]

Updated. Thanks.

Remember about Pro Plus

btw. Update profile (Account details) about Excel version - less troubles & wasted posts