Hi,
There are 9000 rows of Stock market transactions that need to be Concatenated.
This is how to process.
In the Excel sheet name “Use this data” you will find 9000 lines of transactions.
I need you to regroup theses transactions by Date Company name and Type
The type of transaction can only be Buying or Selling. You will know that by looking at the sign in column “D Quantity”:
For example, if “column D” is filled with “ -2000 “, then it is a selling transaction, otherwise if “column D” is filling with a positive number like “1000 “then it is positive transaction.
So, from that you need to create a new column mentioning either buying/selling with a color code displaying on the full line either green or red.
Then you can start the process of Concatenation, that means you have to regroup for the same day buying et selling transaction for each particular stock.
Work should be given in one excel file. It’s a very fast job to do when you know how to use excel.
Other job that need to be done after this one since a Dashboard has to be done from this data.
Do not hesitate to ask if you have any queries
Kindly
Chris