Hello all, I have some data in my Excel file that is formatted as in the picture here http://imgur.com/a/wqcc4 (the actual file is much larger but follows this exact format in the BEFORE pic including the empty row in between each of the "Items").
Is there any formula or macro that would be able to output this into a database friendly format (what is in the AFTER pic)? What I want is to have the customer name in the first column, the item name in the second column, whether or not the customer liked/disliked or had no preference to the item in the third column, how many of the item they bought in the fourth column and finally how many times the customer visited the store to buy Itemx.
I am familiar with the OFFSET function but couldn't think of a way for it to work here so it seems like this would have to be a macro. However, if at all possible I would prefer a formula no matter how complex it may be. Any help at all would be appreciated!
Is there any formula or macro that would be able to output this into a database friendly format (what is in the AFTER pic)? What I want is to have the customer name in the first column, the item name in the second column, whether or not the customer liked/disliked or had no preference to the item in the third column, how many of the item they bought in the fourth column and finally how many times the customer visited the store to buy Itemx.
I am familiar with the OFFSET function but couldn't think of a way for it to work here so it seems like this would have to be a macro. However, if at all possible I would prefer a formula no matter how complex it may be. Any help at all would be appreciated!
Last edited: