Hi, If row has any cell values, need to get column header values one by one in separate cells by clicking the event or cell change event. Sheet 1: <table> <tr> <td>Name</td> <td>Maths</td> <td>Science</td> <td>Social</td> </tr> <tr> <td>AAA</td> <td>1</td> <td></td> <td>3</td> </tr><tr> <td>BBB</td> <td></td> <td>3</td> <td></td> </tr><tr> <td>CCC</td> <td></td> <td></td> <td></td> </tr></table> Sheet 2 <table> <tr> <td>Name</td> <td></td> <td></td> <td></td> </tr> <tr> <td>AAA</td> <td>Maths</td> <td>Social</td> <td></td> </tr><tr> <td>BBB</td> <td>Science</td> <td></td> <td></td> </tr><tr> <td>CCC</td> <td></td> <td></td> <td></td> </tr></table> Thank you.

Support is Online

We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.

Official support hours

Monday To Friday

From 09:00 To 17:30

New

Get Column Header Values Based on Row Has Any Cell Values

Excel

siva.venkatnan

Monday, 11 March 2019

0 Replies

1.7K Visits

Votes

Undo

Hi,

If row has any cell values, need to get column header values one by one in separate cells by clicking the event or cell change event.

Sheet 1:

Name	Maths	Science	Social
AAA	1		3
BBB		3
CCC

Sheet 2

Name
AAA	Maths	Social
BBB	Science
CCC

Thank you.

There are no replies made for this post yet.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Changelog

Feature Tutorials

Get Help?

Get Column Header Values Based on Row Has Any Cell Values

Follow Us