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

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Name[/td][td=bgcolor:#5B9BD5]Date[/td][td][/td][td=bgcolor:#70AD47]Name[/td][td=bgcolor:#70AD47]Date[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]EUC[/td][td=bgcolor:#DDEBF7]

20/10/2019​

[/td][td][/td][td=bgcolor:#E2EFDA]EUC[/td][td=bgcolor:#E2EFDA]

20/10/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]SBKC[/td][td]

20/10/2019​

[/td][td][/td][td]EUC[/td][td]

21/10/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]NBS[/td][td=bgcolor:#DDEBF7]

20/10/2019​

[/td][td][/td][td=bgcolor:#E2EFDA]EUC[/td][td=bgcolor:#E2EFDA]

22/10/2019​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]EUC[/td][td]

21/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]SBKC[/td][td=bgcolor:#DDEBF7]

21/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]NBS[/td][td]

21/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]EUC[/td][td=bgcolor:#DDEBF7]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]SBKC[/td][td]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]NBS[/td][td=bgcolor:#DDEBF7]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]

[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

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Name[/td][td=bgcolor:#5B9BD5]Date[/td][td][/td][td=bgcolor:#DDEBF7]Name[/td][td=bgcolor:#DDEBF7]EUC[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]EUC[/td][td=bgcolor:#DDEBF7]

20/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]SBKC[/td][td]

20/10/2019​

[/td][td][/td][td=bgcolor:#DDEBF7]Date[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]NBS[/td][td=bgcolor:#DDEBF7]

20/10/2019​

[/td][td][/td][td]

20/10/2019​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]EUC[/td][td]

21/10/2019​

[/td][td][/td][td]

21/10/2019​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]SBKC[/td][td=bgcolor:#DDEBF7]

21/10/2019​

[/td][td][/td][td]

22/10/2019​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]NBS[/td][td]

21/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]EUC[/td][td=bgcolor:#DDEBF7]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]SBKC[/td][td]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]NBS[/td][td=bgcolor:#DDEBF7]

22/10/2019​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]

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