Need a formula which can put together a set of data which are in different places

[Akhlaaq97]

If A3,B3,C3 are blank put No
If A3,B3,C3 have values then have to display them along with the the heading in A1,B1 and C1

Have attached a sheet for reference

Thank you.

[etaf]

an example of the out put you need to show would have helped
anyway
you say latest version of excel - better to put the actual version as that changes over time
so 365 is the latest
and has TEXTJOIN

maybe
=IF(AND(A3="",B3="",C3=""),"",TEXTJOIN(",",,A1,A3,B1,B3,C1,C3))

this will put header from A1 and then value in A3 , etc

[Akhlaaq97]

Hi Etaf,

My bad i guess i havent described the output i need clearly
as per my sheet it has Highlights as the heading and the data is product has strength, flexible, versatile
so i need the output to be like this

Highlights
strength, flexible, versatile

Ingredients
this is ingredients

Size
this is size

the output of the formula should be like the above example
if you could assist me with that it'll be really great

[etaf]

can you show that as an example out put in the spreadsheet
your say in A3
product has strength, flexible, versatile
BUT you only want the specific words - what other examples are there ???
also when you say the out put like this - is that a new line - we can use char(10) to set a line break

=IF(AND(A3="",B3="",C3=""),"",TEXTJOIN(CHAR(10),,A1,A3,B1,B3,C1,C3))
which will do this
Highlights
strength, flexible, versatile
Ingredients
this is ingredients
Size
this is size

otherwise a bit messy
=IF(AND(A3="",B3="",C3=""),"",TEXTJOIN(CHAR(10),,A1,A3&CHAR(10),B1,B3&CHAR(10),C1,C3&CHAR(10)))

[kvsrinivasamurthy]

In F2 copied down

Please Login or Register  to view this content.

[Akhlaaq97]

Hi Etaf ,

The formula works just fine thanks to you,
need another help too the headings such as highlights,ingredients and size i need to bold them
can you help me out in this too?

Thanks in advance

[etaf]

As far as i know this cannot be done with a function or with conditional formatting and needs VBA

as its a new part of the question, it may be worth starting a new thread with this question - under the VBA section

I dont provide VBA solutions on the forum, so cannot help for that question

glad the formula word so fat for you