Randomizing data to gain more data

[vk7]

I wanted to randomize data to the maximum possibility for one of my testing purpose. Any help on this would be appreciated. I have attached a excel sheet with this message, which contains two sheets (Raw & Expected).

Raw Sheet contains the original data where as the Expected Sheet contains the data where I have manually randomized it. The idea is to populate as many records as possible from the original input (which in this case is the Raw Sheet).

Note: As of now, the attached excel sheet contains 2 rows and 7 columns. But this can vary always. It can also be 500 rows and 20 columns. I wanted to populate as many records as possible from the Raw input.

 

[Hui]

Have a look at:

https://mockaroo.com/
https://www.generatedata.com/
or
http://www.databasetestdata.com/

These are all free online random data generators

you could also have a read of:
https://chandoo.org/wp/dummy-data-random-functions/