Hi, I am new to this Forum, and don't have extensive knowledge of Excel.
I exported a list from SharePoint to Excel and they got exported as shown on example 1. Is there any codes/macros to convert them to display them as example 2. The lists have hundreds of names, and I have to export the list on monthly basis, so doing it manually would take a lot of time. Any kind of help is highly appreciated. Please let me know if you need more info.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Thanks,
Ralive
I exported a list from SharePoint to Excel and they got exported as shown on example 1. Is there any codes/macros to convert them to display them as example 2. The lists have hundreds of names, and I have to export the list on monthly basis, so doing it manually would take a lot of time. Any kind of help is highly appreciated. Please let me know if you need more info.
Example 1 |
<tbody>
</tbody>
Title | Name | Address |
Manager | Tom, Harry, Ram | NY, VA, NJ |
<tbody>
</tbody>
Example 2 | ||
Title | Name | Address |
Manager | Tom | NY |
Manager | Harry | VA |
Manager | Ram | NJ |
<tbody>
</tbody>
Thanks,
Ralive
Last edited: