contraububu
New Member
- Joined
- Nov 18, 2013
- Messages
- 17
Hi All! Can you help me with this excel function? I have a list of events that displayed vertically, and I would like to show the data horizontally one line for each person. Here is how the data looks now:
<tbody>
</tbody>
And this is what I would like to show the data in this format (horizontally) on a separate sheet:
<tbody>
</tbody>
I'm not <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> savvy honestly; however, let me know what information I need to replace/rename so that your VBA codes will work. Thanks so much!
A | B | C | |
1 | Michael | 09/15/2016 | Egg |
2 | Michael | 04/01/2016 | Basket |
3 | Michael | 09/08/2016 | Fold |
4 | Frank | 10/16/2015 | Knife |
5 | Edmond | 10/16/2015 | Napkins |
6 | Lina | 04/01/2016 | Paper |
7 | Lina | 09/01/2016 | Fold |
8 | Laura | 04/01/2016 | Basket |
9 | Laura | 07/23/2016 | Tissues |
<tbody>
</tbody>
And this is what I would like to show the data in this format (horizontally) on a separate sheet:
Michael | 09/15/2016 | Egg | 04/01/2016 | Basket | 09/08/2016 | Fold |
Frank | 10/16/2015 | Knife | ||||
Edmond | 10/16/2015 | Napkins | ||||
Lina | 04/01/2016 | Paper | 09/01/2016 | Fold | ||
Laura | 04/01/2016 | Basket | 07/23/2016 | Tissues |
<tbody>
</tbody>
I'm not <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> savvy honestly; however, let me know what information I need to replace/rename so that your VBA codes will work. Thanks so much!