LBee
New Member
- Joined
- Dec 25, 2021
- Messages
- 20
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all
I'm trying to create at macro, that makes data more readable by creating a two-dimensional view, but I'm so stuck.
Using data from examples found on differeny webpages, I mange to either have data from column a in rows or data from column B in columns, but I have no idea how to combine those
I have made a simple example, to illustrate what data looks like, and what my goal is
Data looks like this
And my goal is to create a new sheet looking like this :
Does it make sense and if yes, is it even possible to do what I'm trying to do?
I'm trying to create at macro, that makes data more readable by creating a two-dimensional view, but I'm so stuck.
Using data from examples found on differeny webpages, I mange to either have data from column a in rows or data from column B in columns, but I have no idea how to combine those
I have made a simple example, to illustrate what data looks like, and what my goal is
Data looks like this
Customer | Product |
Customer1 | a |
Customer1 | c |
Customer2 | a |
Customer2 | d |
Customer2 | e |
Customer2 | f |
Customer3 | a |
Customer3 | b |
Customer3 | c |
Customer3 | d |
Customer3 | e |
Customer4 | a |
Customer4 | e |
And my goal is to create a new sheet looking like this :
Customer1 | a | c | |||
Customer2 | a | d | e | f | |
Customer3 | a | b | c | d | e |
Customer4 | a | e | |||
Does it make sense and if yes, is it even possible to do what I'm trying to do?