SET SESSION group_concat_max_len = 1000000;

SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
    CONCAT(
      'MAX(CASE WHEN f1.Tank_ID= ''',
      f1.Tank_ID,
      ''' THEN nf1.'Receipt' END) AS '
      f1.Tank
    )
   )INTO @sql
FROM
    tank_details AS nf1
        RIGHT JOIN
    tank AS f1 ON f1.Tank_ID = nf1.Tank_ID
    group by DATE(`Date`);

Tank_ID      Tank
1            Tank 1
2            Tank 2
3            Tank 3
4            Tank 4
5            Tank 5

Tank_ID    Receipt    Date
1          1000       2019-07-10
2          2000       2019-07-10
3          3000       2019-07-10
1           0         2019-07-10
1           0         2019-07-15
3           0         2019-07-15
2           0         2019-07-15
3           0         2019-07-15
1           250       2019-07-15
2           200       2019-07-15
3           800       2019-07-15
1           250       2019-07-15
4           350       2019-07-15
1           0         2019-07-20
2           0         2019-07-20
3           0         2019-07-20
4           0         2019-07-20
1           300       2019-07-20
2          1200       2019-07-20
3          1400       2019-07-20
4          900        2019-07-20
5           20        2019-07-20
1          500        2019-07-20

Date         Receipt      Tank 1    Tank 2   Tank 3    Tank 4     Tank 5
2019-07-10    6000         1000     2000     3000       NULL       NULL
2019-07-15    1850         500       200      800       350        NULL
2019-07-20    4320         800      1200     1400       900        20