Copying Multiple Results into Different Tab

[joshtak]

Hello,

I have all my Data on a tab called "Queue Data". In Column A is the Queue Name. Column B has dates. This tab will have daily data put into it so the names of each queue will be listed multiple times and will look like the below example:

Name Date
EUC 10/20/19
SBKC 10/20/19
NBS 10/20/19
EUC 10/21/19
SBKC 10/21/19
NBS 10/21/19
EUC 10/22/19
SBKC 10/22/19
NBS 10/22/19

I have another tab called "EUC" which I would like all of the dates for EUC to appear in Column B. The first one in row 2, the second one in row 3 and so on.

Would appreciate any help with a formula for this!

Thank you!

 

[sandy666]

Re: Help with Copying Multiple Results into Different Tab

you can try Power Query aka Get&Transform

Name	Date		Name	Date
EUC	20/10/2019​		EUC	20/10/2019​
SBKC	20/10/2019​		EUC	21/10/2019​
NBS	20/10/2019​		EUC	22/10/2019​
EUC	21/10/2019​
SBKC	21/10/2019​
NBS	21/10/2019​
EUC	22/10/2019​
SBKC	22/10/2019​
NBS	22/10/2019​

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Date", type date}}),
    Filter = Table.SelectRows(Type, each ([Name] = "EUC"))
in
    Filter[/SIZE]

result table (green) can be loaded wherever you want

btw. this is NOT vba!

or you can use simple Pivot Table

Name	Date		Name	EUC
EUC	20/10/2019​
SBKC	20/10/2019​		Date
NBS	20/10/2019​		20/10/2019​
EUC	21/10/2019​		21/10/2019​
SBKC	21/10/2019​		22/10/2019​
NBS	21/10/2019​
EUC	22/10/2019​
SBKC	22/10/2019​
NBS	22/10/2019​

edit: in both cases, after any change in source table, refresh QueryTable or PivotTable