from coloumn values to cell data [TEXTJOIN Fn in VBA form]

[Mehmud Khan]

Dear Friends,

Good day!

Need assistance in attached excel.

Thankful if someone could help.

Difficult to explain in text, if check the attached file then you will understand my issue.

Thanks in advance for help.

-MK

 

[Mehmud Khan]

one of excel ninja was helped me (in formula format) but unfortunately it was not working in my excel.

data from coloumn crieteria to in a cell.

Dear Friends, Need your valuable assistance. somebody can please help me in attached query. Thanks in advance. MK

chandoo.org

Thanks

 

[vletm]

Mehmud Khan
Why are cells C13 & C14 empty?

 

[Mehmud Khan]

Thanks for your reply vletm......

Sorry! it was my mistake...
please delete C13 and C14.....

consider as below;

 

[vletm]

Mehmud Khan
C13 and C14 are empty ... then why delete empty cells?
eg if there is Your file kind of case with rows 13 & 14 - what are correct results?
If someone tries to make any code then You should give clear rules - what should do?
Or
If You could use Pivot-table ...
would it give result - which solves something?

 

[AlanSidman]

An option available to you is Power Pivot. Create a measure

=CONCATENATEX(range,Range[Title2]," | ")

 

[Mehmud Khan]

Mehmud Khan
C13 and C14 are empty ... then why delete empty cells?
eg if there is Your file kind of case with rows 13 & 14 - what are correct results?
If someone tries to make any code then You should give clear rules - what should do?
Or
If You could use Pivot-table ...
would it give result - which solves something?

Thanks you so much vletm...
your inputs are really appreciable....
unfortunately its not the solution....

AlanSidman provided the more useful solution...

Thanks once again for your precious time...

 

[Mehmud Khan]

An option available to you is Power Pivot. Create a measure

=CONCATENATEX(range,Range[Title2]," | ")

Hello AlanSidman,

Thanks you very much for your reply...
first of all so sorry.. may be i am not able to explain the issue properly... also sorry for bad english...

but still you gave the more useful solution.

but how you use this kind of pivot...

I am still not able to create a pivot table like you...



Thanks once again..
Please help..

-mehmud

 

[vletm]

Mehmud Khan
How it could be the solution, if You skip to answer eg to those three question?

 

[AlanSidman]

This should help you to understand what I did

https://sfmagazine.com/articles/2018/july/excel-reporting-text-in-a-pivot-table/

 

[vletm]

Mehmud Khan
Here to sample VBA.
Usage:
Keep Your data same format as in Your sample.
Press one of [ Do It ]-button.

 

[Mehmud Khan]

Mehmud Khan
Here to sample VBA.
Usage:
Keep Your data same format as in Your sample.
Press one of [ Do It ]-button.

Dear vletm,

You are really superb..

1. the first one is not the solution.
2. the second is the exact solution which I am looking.

thanks you very much..
regards from mumbai...

 

[vletm]

Mehmud Khan
The 1st one is as well as the solution, if You've used colors as You've used with Your file.